Profiling Report

Dataset statistics

Number of variables	22
Number of observations	40309
Missing cells	24170
Missing cells (%)	2.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.4 MiB
Average record size in memory	141.3 B

Variable types

Text	5
Numeric	8
Categorical	9

Alerts

`modelo` has a high cardinality: 939 distinct values	High cardinality
`tipo_de_combustible` is highly imbalanced (70.5%)	Imbalance
`motor` has 3008 (7.5%) missing values	Missing
`cilindrada` has 8992 (22.3%) missing values	Missing
`potencia` has 8735 (21.7%) missing values	Missing
`control_de_traccion` has 3433 (8.5%) missing values	Missing
`kilometros` is highly skewed (γ1 = 30.08883515)	Skewed
`id_car` has unique values	Unique
`link` has unique values	Unique
`age` has 747 (1.9%) zeros	Zeros

Reproduction

Analysis started	2024-05-20 05:23:29.137457
Analysis finished	2024-05-20 05:23:38.270951
Duration	9.13 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

id_car
Text

UNIQUE

Distinct	40309
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	524017
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	40309 ?
Unique (%)	100.0%

Sample

1st row	MCO2391186016
2nd row	MCO2391197332
3rd row	MCO1426750375
4th row	MCO1426711773
5th row	MCO1425593285

Value	Count	Frequency (%)
mco2391186016	1	< 0.1%
mco2364656310	1	< 0.1%
mco1426750375	1	< 0.1%
mco1426711773	1	< 0.1%
mco1425593285	1	< 0.1%
mco2387326852	1	< 0.1%
mco1424639637	1	< 0.1%
mco1423454057	1	< 0.1%
mco2375421964	1	< 0.1%
mco1424598805	1	< 0.1%
Other values (40299)	40299	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
2	61047	11.6%
1	56908	10.9%
4	48709	9.3%
3	47908	9.1%
M	40309	7.7%
C	40309	7.7%
O	40309	7.7%
6	33743	6.4%
5	32966	6.3%
0	30992	5.9%
Other values (3)	90817	17.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	524017	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	61047	11.6%
1	56908	10.9%
4	48709	9.3%
3	47908	9.1%
M	40309	7.7%
C	40309	7.7%
O	40309	7.7%
6	33743	6.4%
5	32966	6.3%
0	30992	5.9%
Other values (3)	90817	17.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	524017	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	61047	11.6%
1	56908	10.9%
4	48709	9.3%
3	47908	9.1%
M	40309	7.7%
C	40309	7.7%
O	40309	7.7%
6	33743	6.4%
5	32966	6.3%
0	30992	5.9%
Other values (3)	90817	17.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	524017	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	61047	11.6%
1	56908	10.9%
4	48709	9.3%
3	47908	9.1%
M	40309	7.7%
C	40309	7.7%
O	40309	7.7%
6	33743	6.4%
5	32966	6.3%
0	30992	5.9%
Other values (3)	90817	17.3%

title
Text

Distinct	25469
Distinct (%)	63.2%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

Length

Max length	60
Median length	48
Mean length	29.909648
Min length	3

Characters and Unicode

Total characters	1205628
Distinct characters	103
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20846 ?
Unique (%)	51.7%

Sample

1st row	Jeep Compass 2.4 Limited
2nd row	Mazda 2 1.5 2010
3rd row	Mazda 3 Lxha7 At 2.0 2010
4th row	Renault Kangoo F76 1.6 2010
5th row	Hyundai Tucson

Value	Count	Frequency (%)
2.0	5111	2.4%
chevrolet	5009	2.4%
renault	4848	2.3%
1.6	4603	2.2%
toyota	3967	1.9%
mazda	3699	1.7%
ford	3466	1.6%
nissan	3018	1.4%
kia	2642	1.2%
4x4	2608	1.2%
Other values (4969)	173257	81.6%

Most occurring characters

Value	Count	Frequency (%)
	179467	14.9%
e	72555	6.0%
a	65062	5.4%
o	59468	4.9%
2	55096	4.6%
i	51317	4.3%
t	50213	4.2%
r	49522	4.1%
0	47203	3.9%
n	45184	3.7%
Other values (93)	530541	44.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1205628	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	179467	14.9%
e	72555	6.0%
a	65062	5.4%
o	59468	4.9%
2	55096	4.6%
i	51317	4.3%
t	50213	4.2%
r	49522	4.1%
0	47203	3.9%
n	45184	3.7%
Other values (93)	530541	44.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1205628	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	179467	14.9%
e	72555	6.0%
a	65062	5.4%
o	59468	4.9%
2	55096	4.6%
i	51317	4.3%
t	50213	4.2%
r	49522	4.1%
0	47203	3.9%
n	45184	3.7%
Other values (93)	530541	44.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1205628	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	179467	14.9%
e	72555	6.0%
a	65062	5.4%
o	59468	4.9%
2	55096	4.6%
i	51317	4.3%
t	50213	4.2%
r	49522	4.1%
0	47203	3.9%
n	45184	3.7%
Other values (93)	530541	44.0%

link
Text

UNIQUE

Distinct	40309
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

Length

Max length	113
Median length	101
Mean length	82.000248
Min length	56

Characters and Unicode

Total characters	3305348
Distinct characters	45
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	40309 ?
Unique (%)	100.0%

Sample

1st row	https://carro.mercadolibre.com.co/MCO-2391186016-jeep-compass-24-limited-_JM
2nd row	https://carro.mercadolibre.com.co/MCO-2391197332-mazda-2-15-2010-_JM
3rd row	https://carro.mercadolibre.com.co/MCO-1426750375-mazda-3-lxha7-at-20-2010-_JM
4th row	https://carro.mercadolibre.com.co/MCO-1426711773-renault-kangoo-f76-16-2010-_JM
5th row	https://carro.mercadolibre.com.co/MCO-1425593285-hyundai-tucson-_JM

Value	Count	Frequency (%)
https://carro.mercadolibre.com.co/mco-2391186016-jeep-compass-24-limited-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-2364656310-mitsubishi-lancer-20-avanzado-2010-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1426750375-mazda-3-lxha7-at-20-2010-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1426711773-renault-kangoo-f76-16-2010-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1425593285-hyundai-tucson-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-2387326852-renault-stepway-16l-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1424639637-chevrolet-spark-lt-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1423454057-chevrolet-aveo-emotion-16-gt-2010-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-2375421964-kia-sportage-_jm	1	< 0.1%
https://carro.mercadolibre.com.co/mco-1424598805-renault-sandero-16-mecanico-_jm	1	< 0.1%
Other values (40299)	40299	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	295895	9.0%
o	221966	6.7%
r	217981	6.6%
c	197299	6.0%
e	159062	4.8%
a	158991	4.8%
t	145069	4.4%
.	120927	3.7%
/	120927	3.7%
2	116143	3.5%
Other values (35)	1551088	46.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3305348	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	295895	9.0%
o	221966	6.7%
r	217981	6.6%
c	197299	6.0%
e	159062	4.8%
a	158991	4.8%
t	145069	4.4%
.	120927	3.7%
/	120927	3.7%
2	116143	3.5%
Other values (35)	1551088	46.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3305348	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	295895	9.0%
o	221966	6.7%
r	217981	6.6%
c	197299	6.0%
e	159062	4.8%
a	158991	4.8%
t	145069	4.4%
.	120927	3.7%
/	120927	3.7%
2	116143	3.5%
Other values (35)	1551088	46.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3305348	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	295895	9.0%
o	221966	6.7%
r	217981	6.6%
c	197299	6.0%
e	159062	4.8%
a	158991	4.8%
t	145069	4.4%
.	120927	3.7%
/	120927	3.7%
2	116143	3.5%
Other values (35)	1551088	46.9%

price
Real number (ℝ)

Distinct	2380
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90219373

Minimum	1800000
Maximum	2.48 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	1800000
5-th percentile	28000000
Q1	44000000
median	68000000
Q3	1.1 × 10⁸
95-th percentile	2.27 × 10⁸
Maximum	2.48 × 10⁹
Range	2.4782 × 10⁹
Interquartile range (IQR)	66000000

Descriptive statistics

Standard deviation	75456945
Coefficient of variation (CV)	0.83637186
Kurtosis	46.786003
Mean	90219373
Median Absolute Deviation (MAD)	28100000
Skewness	4.1230501
Sum	3.6366527 × 10¹²
Variance	5.6937505 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45000000	350	0.9%
65000000	325	0.8%
55000000	318	0.8%
40000000	311	0.8%
35000000	296	0.7%
42000000	291	0.7%
60000000	290	0.7%
75000000	287	0.7%
38000000	282	0.7%
85000000	269	0.7%
Other values (2370)	37290	92.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1800000	2	< 0.1%
2050000	1	< 0.1%
2100000	1	< 0.1%
3000000	1	< 0.1%
3080000	1	< 0.1%
3750000	1	< 0.1%
3800000	1	< 0.1%
4300000	1	< 0.1%
4900000	1	< 0.1%
5400000	1	< 0.1%

Value	Count	Frequency (%)
2480000000	1	< 0.1%
1290000000	1	< 0.1%
1260000000	1	< 0.1%
1259000000	1	< 0.1%
1190000000	1	< 0.1%
1090000000	1	< 0.1%
1080000000	1	< 0.1%
1030000000	2	< 0.1%
1020000000	1	< 0.1%
999000000	1	< 0.1%

seller_name
Text

Distinct	18947
Distinct (%)	47.0%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

Length

Max length	30
Median length	25
Mean length	14.892605
Min length	3

Characters and Unicode

Total characters	600306
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17384 ?
Unique (%)	43.1%

Sample

1st row	TUC_LAPALMERACHIA
2nd row	ZHERRERA84044
3rd row	OGARZON81312
4th row	JARROYAVE29599
5th row	TUC_SUBA

Value	Count	Frequency (%)
autos	865	1.9%
usados	569	1.2%
sas	534	1.1%
s.a.s	397	0.9%
tuc_calle134	361	0.8%
tuc_paloquemao	298	0.6%
tuc_niza2	281	0.6%
concesionario	243	0.5%
tuc_cvcasatorousadosav68	230	0.5%
rrautosdiego	172	0.4%
Other values (19342)	42720	91.5%

Most occurring characters

Value	Count	Frequency (%)
A	69812	11.6%
O	47656	7.9%
E	36453	6.1%
S	36335	6.1%
R	35427	5.9%
I	29234	4.9%
U	28590	4.8%
C	26497	4.4%
T	25789	4.3%
L	24905	4.1%
Other values (43)	239608	39.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	600306	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	69812	11.6%
O	47656	7.9%
E	36453	6.1%
S	36335	6.1%
R	35427	5.9%
I	29234	4.9%
U	28590	4.8%
C	26497	4.4%
T	25789	4.3%
L	24905	4.1%
Other values (43)	239608	39.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	600306	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	69812	11.6%
O	47656	7.9%
E	36453	6.1%
S	36335	6.1%
R	35427	5.9%
I	29234	4.9%
U	28590	4.8%
C	26497	4.4%
T	25789	4.3%
L	24905	4.1%
Other values (43)	239608	39.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	600306	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	69812	11.6%
O	47656	7.9%
E	36453	6.1%
S	36335	6.1%
R	35427	5.9%
I	29234	4.9%
U	28590	4.8%
C	26497	4.4%
T	25789	4.3%
L	24905	4.1%
Other values (43)	239608	39.9%

city
Categorical

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	355.5 KiB

bogota dc	16138
antioquia	11084
valle del cauca	3549
cundinamarca	1670
atlantico	1453
Other values (21)	6415

Length

Max length	18
Median length	9
Mean length	9.5138307
Min length	4

Characters and Unicode

Total characters	383493
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	bogota dc
2nd row	bogota dc
3rd row	bogota dc
4th row	bogota dc
5th row	bogota dc

Common Values

Value	Count	Frequency (%)
bogota dc	16138	40.0%
antioquia	11084	27.5%
valle del cauca	3549	8.8%
cundinamarca	1670	4.1%
atlantico	1453	3.6%
santander	1302	3.2%
risaralda	1096	2.7%
caldas	548	1.4%
norte de santander	527	1.3%
boyaca	509	1.3%
Other values (16)	2433	6.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bogota	16138	25.0%
dc	16138	25.0%
antioquia	11084	17.2%
cauca	3661	5.7%
valle	3549	5.5%
del	3549	5.5%
santander	1829	2.8%
cundinamarca	1670	2.6%
atlantico	1453	2.2%
risaralda	1096	1.7%
Other values (19)	4432	6.9%

Most occurring characters

Value	Count	Frequency (%)
a	68633	17.9%
o	47287	12.3%
t	33266	8.7%
c	29682	7.7%
i	28116	7.3%
d	25879	6.7%
	24290	6.3%
n	20732	5.4%
b	17099	4.5%
u	17007	4.4%
Other values (13)	71502	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	383493	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	68633	17.9%
o	47287	12.3%
t	33266	8.7%
c	29682	7.7%
i	28116	7.3%
d	25879	6.7%
	24290	6.3%
n	20732	5.4%
b	17099	4.5%
u	17007	4.4%
Other values (13)	71502	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	383493	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	68633	17.9%
o	47287	12.3%
t	33266	8.7%
c	29682	7.7%
i	28116	7.3%
d	25879	6.7%
	24290	6.3%
n	20732	5.4%
b	17099	4.5%
u	17007	4.4%
Other values (13)	71502	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	383493	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	68633	17.9%
o	47287	12.3%
t	33266	8.7%
c	29682	7.7%
i	28116	7.3%
d	25879	6.7%
	24290	6.3%
n	20732	5.4%
b	17099	4.5%
u	17007	4.4%
Other values (13)	71502	18.6%

color
Categorical

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

otro	15381
gris	7162
blanco	6306
plateado	5088
rojo	2318
Other values (8)	4054

Length

Max length	8
Median length	4
Mean length	4.9002456
Min length	4

Characters and Unicode

Total characters	197524
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	negro
2nd row	blanco
3rd row	plateado
4th row	blanco
5th row	plateado

Common Values

Value	Count	Frequency (%)
otro	15381	38.2%
gris	7162	17.8%
blanco	6306	15.6%
plateado	5088	12.6%
rojo	2318	5.8%
negro	2013	5.0%
azul	1420	3.5%
dorado	200	0.5%
marron	162	0.4%
verde	124	0.3%
Other values (3)	135	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
otro	15381	38.2%
gris	7162	17.8%
blanco	6306	15.6%
plateado	5088	12.6%
rojo	2318	5.8%
negro	2013	5.0%
azul	1420	3.5%
dorado	200	0.5%
marron	162	0.4%
verde	124	0.3%
Other values (3)	135	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	49440	25.0%
r	27642	14.0%
t	20484	10.4%
a	18581	9.4%
l	12945	6.6%
g	9175	4.6%
n	8605	4.4%
e	7364	3.7%
i	7235	3.7%
s	7162	3.6%
Other values (9)	28891	14.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	197524	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	49440	25.0%
r	27642	14.0%
t	20484	10.4%
a	18581	9.4%
l	12945	6.6%
g	9175	4.6%
n	8605	4.4%
e	7364	3.7%
i	7235	3.7%
s	7162	3.6%
Other values (9)	28891	14.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	197524	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	49440	25.0%
r	27642	14.0%
t	20484	10.4%
a	18581	9.4%
l	12945	6.6%
g	9175	4.6%
n	8605	4.4%
e	7364	3.7%
i	7235	3.7%
s	7162	3.6%
Other values (9)	28891	14.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	197524	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	49440	25.0%
r	27642	14.0%
t	20484	10.4%
a	18581	9.4%
l	12945	6.6%
g	9175	4.6%
n	8605	4.4%
e	7364	3.7%
i	7235	3.7%
s	7162	3.6%
Other values (9)	28891	14.6%

aire_acondicionado
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	354.4 KiB

si	30711
no	9598

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	80618
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	si
2nd row	si
3rd row	si
4th row	si
5th row	si

Common Values

Value	Count	Frequency (%)
si	30711	76.2%
no	9598	23.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
si	30711	76.2%
no	9598	23.8%

Most occurring characters

Value	Count	Frequency (%)
s	30711	38.1%
i	30711	38.1%
n	9598	11.9%
o	9598	11.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80618	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	30711	38.1%
i	30711	38.1%
n	9598	11.9%
o	9598	11.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80618	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	30711	38.1%
i	30711	38.1%
n	9598	11.9%
o	9598	11.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80618	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	30711	38.1%
i	30711	38.1%
n	9598	11.9%
o	9598	11.9%

marca
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	398.9 KiB

chevrolet	5114
renault	5023
toyota	3996
mazda	3694
ford	3465
Other values (15)	19017

Length

Max length	13
Median length	7
Mean length	6.4364534
Min length	3

Characters and Unicode

Total characters	259447
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	jeep
2nd row	mazda
3rd row	mazda
4th row	renault
5th row	hyundai

Common Values

Value	Count	Frequency (%)
chevrolet	5114	12.7%
renault	5023	12.5%
toyota	3996	9.9%
mazda	3694	9.2%
ford	3465	8.6%
nissan	3028	7.5%
kia	2638	6.5%
volkswagen	2514	6.2%
bmw	2206	5.5%
mercedes_benz	2116	5.2%
Other values (10)	6515	16.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chevrolet	5114	12.7%
renault	5023	12.5%
toyota	3996	9.9%
mazda	3694	9.2%
ford	3465	8.6%
nissan	3028	7.5%
kia	2638	6.5%
volkswagen	2514	6.2%
bmw	2206	5.5%
mercedes_benz	2116	5.2%
Other values (10)	6515	16.2%

Most occurring characters

Value	Count	Frequency (%)
e	28698	11.1%
a	27289	10.5%
o	21384	8.2%
t	18831	7.3%
n	17781	6.9%
r	15718	6.1%
l	13051	5.0%
d	13047	5.0%
s	12632	4.9%
i	10710	4.1%
Other values (15)	80306	31.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	259447	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	28698	11.1%
a	27289	10.5%
o	21384	8.2%
t	18831	7.3%
n	17781	6.9%
r	15718	6.1%
l	13051	5.0%
d	13047	5.0%
s	12632	4.9%
i	10710	4.1%
Other values (15)	80306	31.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	259447	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	28698	11.1%
a	27289	10.5%
o	21384	8.2%
t	18831	7.3%
n	17781	6.9%
r	15718	6.1%
l	13051	5.0%
d	13047	5.0%
s	12632	4.9%
i	10710	4.1%
Other values (15)	80306	31.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	259447	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	28698	11.1%
a	27289	10.5%
o	21384	8.2%
t	18831	7.3%
n	17781	6.9%
r	15718	6.1%
l	13051	5.0%
d	13047	5.0%
s	12632	4.9%
i	10710	4.1%
Other values (15)	80306	31.0%

puertas
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

5	27235
4	10673
2	1982
3	419

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	40309
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	5
3rd row	4
4th row	4
5th row	5

Common Values

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

Most occurring characters

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	40309	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	40309	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	40309	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	27235	67.6%
4	10673	26.5%
2	1982	4.9%
3	419	1.0%

motor
Real number (ℝ)

MISSING

Distinct	45
Distinct (%)	0.1%
Missing	3008
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.0573309

Minimum	0
Maximum	5.7
Zeros	19
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.2
Q1	1.6
median	2
Q3	2.4
95-th percentile	3.6
Maximum	5.7
Range	5.7
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.73446097
Coefficient of variation (CV)	0.35699701
Kurtosis	2.4408306
Mean	2.0573309
Median Absolute Deviation (MAD)	0.4
Skewness	1.3782378
Sum	76740.5
Variance	0.53943292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
2	9019	22.4%
1.6	8020	19.9%
2.5	2655	6.6%
1.8	2045	5.1%
1.4	2002	5.0%
3	1852	4.6%
2.4	1775	4.4%
1.2	1769	4.4%
1.5	1596	4.0%
1	1197	3.0%
Other values (35)	5371	13.3%
(Missing)	3008	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	< 0.1%
0.8	59	0.1%
0.9	1	< 0.1%
1	1197	3.0%
1.1	55	0.1%
1.2	1769	4.4%
1.3	375	0.9%
1.4	2002	5.0%
1.5	1596	4.0%
1.6	8020	19.9%

Value	Count	Frequency (%)
5.7	59	0.1%
5.6	6	< 0.1%
5.5	18	< 0.1%
5.4	5	< 0.1%
5.3	39	0.1%
5.2	3	< 0.1%
5	48	0.1%
4.7	57	0.1%
4.6	26	0.1%
4.5	100	0.2%

tipo_de_combustible
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	354.5 KiB

gasolina	35354
diesel	3300
hibrido	1351
gasolina y gas	203
electrico	101

Length

Max length	14
Median length	8
Mean length	7.835471
Min length	6

Characters and Unicode

Total characters	315840
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	gasolina
2nd row	gasolina
3rd row	gasolina
4th row	gasolina
5th row	gasolina

Common Values

Value	Count	Frequency (%)
gasolina	35354	87.7%
diesel	3300	8.2%
hibrido	1351	3.4%
gasolina y gas	203	0.5%
electrico	101	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gasolina	35557	87.3%
diesel	3300	8.1%
hibrido	1351	3.3%
y	203	0.5%
gas	203	0.5%
electrico	101	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	71317	22.6%
i	41660	13.2%
s	39060	12.4%
l	38958	12.3%
o	37009	11.7%
g	35760	11.3%
n	35557	11.3%
e	6802	2.2%
d	4651	1.5%
r	1452	0.5%
Other values (6)	3614	1.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	315840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	71317	22.6%
i	41660	13.2%
s	39060	12.4%
l	38958	12.3%
o	37009	11.7%
g	35760	11.3%
n	35557	11.3%
e	6802	2.2%
d	4651	1.5%
r	1452	0.5%
Other values (6)	3614	1.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	315840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	71317	22.6%
i	41660	13.2%
s	39060	12.4%
l	38958	12.3%
o	37009	11.7%
g	35760	11.3%
n	35557	11.3%
e	6802	2.2%
d	4651	1.5%
r	1452	0.5%
Other values (6)	3614	1.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	315840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	71317	22.6%
i	41660	13.2%
s	39060	12.4%
l	38958	12.3%
o	37009	11.7%
g	35760	11.3%
n	35557	11.3%
e	6802	2.2%
d	4651	1.5%
r	1452	0.5%
Other values (6)	3614	1.1%

kilometros
Real number (ℝ)

SKEWED

Distinct	9002
Distinct (%)	22.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71182.621

Minimum	1
Maximum	6350000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	1
5-th percentile	8991.6
Q1	33996
median	64000
Q3	98000
95-th percentile	155000
Maximum	6350000
Range	6349999
Interquartile range (IQR)	64004

Descriptive statistics

Standard deviation	60046.899
Coefficient of variation (CV)	0.84356123
Kurtosis	2979.5281
Mean	71182.621
Median Absolute Deviation (MAD)	32000
Skewness	30.088835
Sum	2.8693003 × 10⁹
Variance	3.6056301 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90000	348	0.9%
80000	317	0.8%
60000	311	0.8%
70000	295	0.7%
50000	289	0.7%
75000	287	0.7%
65000	282	0.7%
100000	274	0.7%
45000	263	0.7%
40000	261	0.6%
Other values (8992)	37382	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	78	0.2%
2	2	< 0.1%
3	5	< 0.1%
4	1	< 0.1%
5	7	< 0.1%
6.2	1	< 0.1%
6.4	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
6350000	1	< 0.1%
999999	2	< 0.1%
960020	1	< 0.1%
913000	1	< 0.1%
870000	1	< 0.1%
840666	1	< 0.1%
819000	1	< 0.1%
803802	1	< 0.1%
800000	1	< 0.1%
790000	1	< 0.1%

modelo
Categorical

HIGH CARDINALITY

Distinct	939
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	436.1 KiB

duster	1074
3	969
prado	942
tracker	915
fortuner	841
Other values (934)	35568

Length

Max length	47
Median length	38
Mean length	5.9544767
Min length	0

Characters and Unicode

Total characters	240019
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	447 ?
Unique (%)	1.1%

Sample

1st row	compass
2nd row	2
3rd row	3
4th row	kangoo
5th row	tucson

Common Values

Value	Count	Frequency (%)
duster	1074	2.7%
3	969	2.4%
prado	942	2.3%
tracker	915	2.3%
fortuner	841	2.1%
escape	827	2.1%
cx_5	819	2.0%
logan	817	2.0%
sportage	817	2.0%
sandero	762	1.9%
Other values (929)	31526	78.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
clase	1857	4.0%
3	1392	3.0%
duster	1221	2.6%
2	970	2.1%
prado	966	2.1%
tracker	915	2.0%
sportage	876	1.9%
sandero	863	1.8%
fortuner	851	1.8%
escape	829	1.8%
Other values (745)	36139	77.1%

Most occurring characters

Value	Count	Frequency (%)
a	23802	9.9%
r	22839	9.5%
e	22435	9.3%
o	17840	7.4%
s	15984	6.7%
t	14900	6.2%
c	13842	5.8%
i	11227	4.7%
n	10979	4.6%
l	9563	4.0%
Other values (31)	76608	31.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	240019	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	23802	9.9%
r	22839	9.5%
e	22435	9.3%
o	17840	7.4%
s	15984	6.7%
t	14900	6.2%
c	13842	5.8%
i	11227	4.7%
n	10979	4.6%
l	9563	4.0%
Other values (31)	76608	31.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	240019	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	23802	9.9%
r	22839	9.5%
e	22435	9.3%
o	17840	7.4%
s	15984	6.7%
t	14900	6.2%
c	13842	5.8%
i	11227	4.7%
n	10979	4.6%
l	9563	4.0%
Other values (31)	76608	31.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	240019	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	23802	9.9%
r	22839	9.5%
e	22435	9.3%
o	17840	7.4%
s	15984	6.7%
t	14900	6.2%
c	13842	5.8%
i	11227	4.7%
n	10979	4.6%
l	9563	4.0%
Other values (31)	76608	31.9%

version
Text

Distinct	9308
Distinct (%)	23.1%
Missing	2
Missing (%)	< 0.1%
Memory size	629.8 KiB

Length

Max length	84
Median length	62
Mean length	13.218746
Min length	1

Characters and Unicode

Total characters	532808
Distinct characters	98
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7022 ?
Unique (%)	17.4%

Sample

1st row	2.4 Limited
2nd row	1.5
3rd row	2.0 Lxhm7
4th row	1.6 Express 4 p
5th row	Gl

Value	Count	Frequency (%)
2.0	7526	6.9%
1.6	6669	6.1%
touring	2854	2.6%
at	2381	2.2%
2.5	2168	2.0%
4x4	2130	1.9%
4x2	1996	1.8%
1.8	1873	1.7%
1.4	1823	1.7%
grand	1659	1.5%
Other values (2375)	78686	71.7%

Most occurring characters

Value	Count	Frequency (%)
	69675	13.1%
.	34001	6.4%
i	28560	5.4%
e	23124	4.3%
2	22515	4.2%
t	20391	3.8%
n	19849	3.7%
1	18655	3.5%
0	18055	3.4%
r	16953	3.2%
Other values (88)	261030	49.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	532808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	69675	13.1%
.	34001	6.4%
i	28560	5.4%
e	23124	4.3%
2	22515	4.2%
t	20391	3.8%
n	19849	3.7%
1	18655	3.5%
0	18055	3.4%
r	16953	3.2%
Other values (88)	261030	49.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	532808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	69675	13.1%
.	34001	6.4%
i	28560	5.4%
e	23124	4.3%
2	22515	4.2%
t	20391	3.8%
n	19849	3.7%
1	18655	3.5%
0	18055	3.4%
r	16953	3.2%
Other values (88)	261030	49.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	532808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	69675	13.1%
.	34001	6.4%
i	28560	5.4%
e	23124	4.3%
2	22515	4.2%
t	20391	3.8%
n	19849	3.7%
1	18655	3.5%
0	18055	3.4%
r	16953	3.2%
Other values (88)	261030	49.0%

año
Real number (ℝ)

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2017.4547

Minimum	2010
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2014
median	2018
Q3	2021
95-th percentile	2023
Maximum	2024
Range	14
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.7927821
Coefficient of variation (CV)	0.0018799838
Kurtosis	-1.0305281
Mean	2017.4547
Median Absolute Deviation (MAD)	3
Skewness	-0.16536969
Sum	81321581
Variance	14.385196
Monotonicity	Increasing

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
2020	3652	9.1%
2022	3624	9.0%
2019	3554	8.8%
2017	3483	8.6%
2023	3308	8.2%
2018	3217	8.0%
2015	3071	7.6%
2016	2863	7.1%
2014	2720	6.7%
2021	2537	6.3%
Other values (5)	8280	20.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	984	2.4%
2011	1960	4.9%
2012	2129	5.3%
2013	2460	6.1%
2014	2720	6.7%
2015	3071	7.6%
2016	2863	7.1%
2017	3483	8.6%
2018	3217	8.0%
2019	3554	8.8%

Value	Count	Frequency (%)
2024	747	1.9%
2023	3308	8.2%
2022	3624	9.0%
2021	2537	6.3%
2020	3652	9.1%
2019	3554	8.8%
2018	3217	8.0%
2017	3483	8.6%
2016	2863	7.1%
2015	3071	7.6%

cilindrada
Real number (ℝ)

MISSING

Distinct	42
Distinct (%)	0.1%
Missing	8992
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.0475205

Minimum	-1
Maximum	5.7
Zeros	3
Zeros (%)	< 0.1%
Negative	15
Negative (%)	< 0.1%
Memory size	629.8 KiB

Quantile statistics

Minimum	-1
5-th percentile	1.2
Q1	1.6
median	2
Q3	2.4
95-th percentile	3.5
Maximum	5.7
Range	6.7
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.72012208
Coefficient of variation (CV)	0.35170445
Kurtosis	2.6567473
Mean	2.0475205
Median Absolute Deviation (MAD)	0.4
Skewness	1.3613242
Sum	64122.2
Variance	0.51857581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
2	7737	19.2%
1.6	7033	17.4%
2.5	2176	5.4%
1.8	1831	4.5%
1.4	1704	4.2%
2.4	1487	3.7%
3	1486	3.7%
1.2	1455	3.6%
1.5	1123	2.8%
1	951	2.4%
Other values (32)	4334	10.8%
(Missing)	8992	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	15	< 0.1%
0	3	< 0.1%
0.8	59	0.1%
1	951	2.4%
1.1	47	0.1%
1.2	1455	3.6%
1.3	251	0.6%
1.4	1704	4.2%
1.5	1123	2.8%
1.6	7033	17.4%

Value	Count	Frequency (%)
5.7	52	0.1%
5.6	2	< 0.1%
5.5	22	0.1%
5.4	2	< 0.1%
5.3	16	< 0.1%
5.2	3	< 0.1%
5	25	0.1%
4.7	58	0.1%
4.6	13	< 0.1%
4.5	69	0.2%

capacidad_de_personas
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4026148

Minimum	-1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	9622
Negative (%)	23.9%
Memory size	472.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	2
median	5
Q3	5
95-th percentile	5
Maximum	8
Range	9
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.5586063
Coefficient of variation (CV)	0.75195298
Kurtosis	-0.79110362
Mean	3.4026148
Median Absolute Deviation (MAD)	0
Skewness	-1.051225
Sum	137156
Variance	6.5464663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	28410	70.5%
-1	9622	23.9%
2	2242	5.6%
7	28	0.1%
8	5	< 0.1%
4	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	9622	23.9%
2	2242	5.6%
4	2	< 0.1%
5	28410	70.5%
7	28	0.1%
8	5	< 0.1%

Value	Count	Frequency (%)
8	5	< 0.1%
7	28	0.1%
5	28410	70.5%
4	2	< 0.1%
2	2242	5.6%
-1	9622	23.9%

potencia
Real number (ℝ)

MISSING

Distinct	235
Distinct (%)	0.7%
Missing	8735
Missing (%)	21.7%
Infinite	0
Infinite (%)	0.0%
Mean	158.48809

Minimum	10
Maximum	585
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	10
5-th percentile	81
Q1	109
median	148
Q3	184
95-th percentile	285
Maximum	585
Range	575
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	68.700887
Coefficient of variation (CV)	0.43347665
Kurtosis	3.3126316
Mean	158.48809
Median Absolute Deviation (MAD)	37
Skewness	1.4673777
Sum	5004103
Variance	4719.8118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
138	1405	3.5%
153	1343	3.3%
106	1219	3.0%
170	1202	3.0%
85	910	2.3%
99	776	1.9%
120	770	1.9%
115	733	1.8%
143	711	1.8%
105	710	1.8%
Other values (225)	21795	54.1%
(Missing)	8735	21.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	46	0.1%
11	72	0.2%
12	37	0.1%
13	26	0.1%
47	43	0.1%
55	25	0.1%
56	1	< 0.1%
62	95	0.2%
64	9	< 0.1%
65	156	0.4%

Value	Count	Frequency (%)
585	1	< 0.1%
567	13	< 0.1%
557	2	< 0.1%
555	1	< 0.1%
550	14	< 0.1%
536	1	< 0.1%
525	3	< 0.1%
523	2	< 0.1%
503	1	< 0.1%
497	1	< 0.1%

control_de_traccion
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	3433
Missing (%)	8.5%
Memory size	354.5 KiB

delantera	14800
4x4	11308
4x2	9794
trasera	974

Length

Max length	9
Median length	3
Mean length	5.5137217
Min length	3

Characters and Unicode

Total characters	203324
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4x4
2nd row	delantera
3rd row	delantera
4th row	4x2
5th row	delantera

Common Values

Value	Count	Frequency (%)
delantera	14800	36.7%
4x4	11308	28.1%
4x2	9794	24.3%
trasera	974	2.4%
(Missing)	3433	8.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delantera	14800	40.1%
4x4	11308	30.7%
4x2	9794	26.6%
trasera	974	2.6%

Most occurring characters

Value	Count	Frequency (%)
4	32410	15.9%
a	31548	15.5%
e	30574	15.0%
x	21102	10.4%
r	16748	8.2%
t	15774	7.8%
d	14800	7.3%
l	14800	7.3%
n	14800	7.3%
2	9794	4.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203324	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	32410	15.9%
a	31548	15.5%
e	30574	15.0%
x	21102	10.4%
r	16748	8.2%
t	15774	7.8%
d	14800	7.3%
l	14800	7.3%
n	14800	7.3%
2	9794	4.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203324	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	32410	15.9%
a	31548	15.5%
e	30574	15.0%
x	21102	10.4%
r	16748	8.2%
t	15774	7.8%
d	14800	7.3%
l	14800	7.3%
n	14800	7.3%
2	9794	4.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203324	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	32410	15.9%
a	31548	15.5%
e	30574	15.0%
x	21102	10.4%
r	16748	8.2%
t	15774	7.8%
d	14800	7.3%
l	14800	7.3%
n	14800	7.3%
2	9794	4.8%

transmision
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	629.8 KiB

automatica	22061
mecanica	18248

Length

Max length	10
Median length	10
Mean length	9.0945943
Min length	8

Characters and Unicode

Total characters	366594
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	mecanica
2nd row	automatica
3rd row	automatica
4th row	mecanica
5th row	mecanica

Common Values

Value	Count	Frequency (%)
automatica	22061	54.7%
mecanica	18248	45.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatica	22061	54.7%
mecanica	18248	45.3%

Most occurring characters

Value	Count	Frequency (%)
a	102679	28.0%
c	58557	16.0%
t	44122	12.0%
m	40309	11.0%
i	40309	11.0%
u	22061	6.0%
o	22061	6.0%
e	18248	5.0%
n	18248	5.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	366594	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	102679	28.0%
c	58557	16.0%
t	44122	12.0%
m	40309	11.0%
i	40309	11.0%
u	22061	6.0%
o	22061	6.0%
e	18248	5.0%
n	18248	5.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	366594	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	102679	28.0%
c	58557	16.0%
t	44122	12.0%
m	40309	11.0%
i	40309	11.0%
u	22061	6.0%
o	22061	6.0%
e	18248	5.0%
n	18248	5.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	366594	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	102679	28.0%
c	58557	16.0%
t	44122	12.0%
m	40309	11.0%
i	40309	11.0%
u	22061	6.0%
o	22061	6.0%
e	18248	5.0%
n	18248	5.0%

age
Real number (ℝ)

ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5453125

Minimum	0
Maximum	14
Zeros	747
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	629.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	10
95-th percentile	13
Maximum	14
Range	14
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.7927821
Coefficient of variation (CV)	0.5794654
Kurtosis	-1.0305281
Mean	6.5453125
Median Absolute Deviation (MAD)	3
Skewness	0.16536969
Sum	263835
Variance	14.385196
Monotonicity	Decreasing

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
4	3652	9.1%
2	3624	9.0%
5	3554	8.8%
7	3483	8.6%
1	3308	8.2%
6	3217	8.0%
9	3071	7.6%
8	2863	7.1%
10	2720	6.7%
3	2537	6.3%
Other values (5)	8280	20.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	747	1.9%
1	3308	8.2%
2	3624	9.0%
3	2537	6.3%
4	3652	9.1%
5	3554	8.8%
6	3217	8.0%
7	3483	8.6%
8	2863	7.1%
9	3071	7.6%

Value	Count	Frequency (%)
14	984	2.4%
13	1960	4.9%
12	2129	5.3%
11	2460	6.1%
10	2720	6.7%
9	3071	7.6%
8	2863	7.1%
7	3483	8.6%
6	3217	8.0%
5	3554	8.8%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id_car	title	link	price	seller_name	city	color	aire_acondicionado	marca	puertas	motor	tipo_de_combustible	kilometros	modelo	version	año	cilindrada	capacidad_de_personas	potencia	control_de_traccion	transmision	age
0	MCO2391186016	Jeep Compass 2.4 Limited	https://carro.mercadolibre.com.co/MCO-2391186016-jeep-compass-24-limited-_JM	37990000	TUC_LAPALMERACHIA	bogota dc	negro	si	jeep	5	2.4	gasolina	182000.0	compass	2.4 Limited	2010	2.4	5	172.0	4x4	mecanica	14
1	MCO2391197332	Mazda 2 1.5 2010	https://carro.mercadolibre.com.co/MCO-2391197332-mazda-2-15-2010-_JM	32000000	ZHERRERA84044	bogota dc	blanco	si	mazda	5	1.5	gasolina	146330.0	2	1.5	2010	NaN	-1	NaN	NaN	automatica	14
2	MCO1426750375	Mazda 3 Lxha7 At 2.0 2010	https://carro.mercadolibre.com.co/MCO-1426750375-mazda-3-lxha7-at-20-2010-_JM	30500000	OGARZON81312	bogota dc	plateado	si	mazda	4	2.0	gasolina	106000.0	3	2.0 Lxhm7	2010	2.0	5	145.0	delantera	automatica	14
3	MCO1426711773	Renault Kangoo F76 1.6 2010	https://carro.mercadolibre.com.co/MCO-1426711773-renault-kangoo-f76-16-2010-_JM	24500000	JARROYAVE29599	bogota dc	blanco	si	renault	4	1.6	gasolina	170500.0	kangoo	1.6 Express 4 p	2010	1.6	2	95.0	delantera	mecanica	14
4	MCO1425593285	Hyundai Tucson	https://carro.mercadolibre.com.co/MCO-1425593285-hyundai-tucson-_JM	43000000	TUC_SUBA	bogota dc	plateado	si	hyundai	5	2.0	gasolina	110050.0	tucson	Gl	2010	NaN	-1	NaN	4x2	mecanica	14
5	MCO2387326852	Renault Stepway 1.6l	https://carro.mercadolibre.com.co/MCO-2387326852-renault-stepway-16l-_JM	27000000	ABARRERO21250	bogota dc	rojo	si	renault	5	1.6	gasolina	94783.0	stepway	1.6l	2010	1.6	5	110.0	delantera	mecanica	14
6	MCO1424639637	Chevrolet Spark Lt	https://carro.mercadolibre.com.co/MCO-1424639637-chevrolet-spark-lt-_JM	21500000	TUC_CALLE134	bogota dc	gris	no	chevrolet	5	1.0	gasolina	92000.0	spark	1.0 Lt	2010	1.0	5	62.0	4x2	mecanica	14
7	MCO1423454057	Chevrolet Aveo Emotion 1.6 Gt 2010	https://carro.mercadolibre.com.co/MCO-1423454057-chevrolet-aveo-emotion-16-gt-2010-_JM	25800000	JLEON86105	bogota dc	plateado	si	chevrolet	5	1.6	gasolina	146000.0	aveo emotion	1.6 Gt	2010	NaN	-1	NaN	NaN	mecanica	14
8	MCO2375421964	Kia Sportage	https://carro.mercadolibre.com.co/MCO-2375421964-kia-sportage-_JM	36500000	TUC_KENNEDY	bogota dc	plateado	si	kia	5	2.0	gasolina	125403.0	sportage	2.0 Lx 4x2	2010	NaN	-1	NaN	NaN	mecanica	14
9	MCO1422666347	Honda Civic Lx 1.8	https://carro.mercadolibre.com.co/MCO-1422666347-honda-civic-lx-18-_JM	36000000	JMARTINEZ83902	bogota dc	blanco	si	honda	4	1.8	gasolina	116000.0	civic	1.8 Lx	2010	1.8	5	140.0	delantera	mecanica	14

	id_car	title	link	price	seller_name	city	color	aire_acondicionado	marca	puertas	motor	tipo_de_combustible	kilometros	modelo	version	año	cilindrada	capacidad_de_personas	potencia	control_de_traccion	transmision
43337	MCO1419381819	Renault Sandero 2024 1.6 Life Plus	https://carro.mercadolibre.com.co/MCO-1419381819-renault-sandero-2024-16-life-plus-_JM	64090000	SANTIAGOOSPINA610	antioquia	otro	no	renault	5	1.6	gasolina	1.0	sandero	1.6 Life Plus	2024	NaN	-1	113.0	delantera	mecanica
43338	MCO1420833527	Cheviplan	https://carro.mercadolibre.com.co/MCO-1420833527-cheviplan-_JM	3750000	ANDORES	antioquia	blanco	no	chevrolet	4	1.4	gasolina	5000.0	n_a	24	2024	NaN	-1	NaN	delantera	automatica
43339	MCO2391833712	Renault Duster 2024 1.3 T Iconic Mt 4x4	https://carro.mercadolibre.com.co/MCO-2391833712-renault-duster-2024-13-t-iconic-mt-4x4-_JM	94000000	CARLOSFERNEYMOYAMARTN	antioquia	otro	si	renault	5	1.3	gasolina	5718.0	duster	1.3 T Iconic Mt 4X4	2024	1.3	5	154.0	4x4	mecanica
43340	MCO1423756669	Mazda 3 Touring	https://carro.mercadolibre.com.co/MCO-1423756669-mazda-3-touring-_JM	112000000	GOSE5905441	valle del cauca	otro	no	mazda	5	NaN	hibrido	14000.0	3	Touring	2024	NaN	-1	NaN	NaN	mecanica
43341	MCO2358833262	Bmw X3 Idrive30i 2023	https://carro.mercadolibre.com.co/MCO-2358833262-bmw-x3-idrive30i-2023-_JM	235000000	LORU20240503163322	bogota dc	azul	si	bmw	5	2.0	gasolina	6300.0	x3	2.0 Xdrive30i	2024	2.0	5	252.0	4x4	automatica
43342	MCO1419580825	Mazda Cx-5 2024 2.0 Touring 4x2 Aut	https://carro.mercadolibre.com.co/MCO-1419580825-mazda-cx-5-2024-20-touring-4x2-aut-_JM	120000000	JIMENEZVICTOR20220202210039	caldas	otro	no	mazda	5	2.0	gasolina	14000.0	cx_5	2.0 Touring 4X2 Aut	2024	NaN	-1	154.0	4x2	automatica
43343	MCO1420286429	Mazda Cx-5 2024 2.5 Touring 4x2 Aut	https://carro.mercadolibre.com.co/MCO-1420286429-mazda-cx-5-2024-25-touring-4x2-aut-_JM	135000000	ZEDI6261157	valle del cauca	otro	no	mazda	5	2.5	gasolina	19000.0	cx_5	2.5 Touring 4X2 Aut	2024	NaN	-1	188.0	4x2	automatica
43344	MCO2347166584	Toyota Corolla Cross Xei Hybrid	https://carro.mercadolibre.com.co/MCO-2347166584-toyota-corolla-cross-xei-hybrid-_JM	131000000	TUC_CALLE134	cundinamarca	gris	si	toyota	5	1.8	hibrido	15600.0	corolla cross	1.8 Xei Hybrid	2024	NaN	-1	97.0	4x2	automatica
43345	MCO1415231981	Renault Duster Iconic 1.3 Turbo 4x4	https://carro.mercadolibre.com.co/MCO-1415231981-renault-duster-iconic-13-turbo-4x4-_JM	98000000	ACUEVAS33614	bogota dc	gris	si	renault	5	1.3	gasolina	1483.0	duster	ICONIC 1.3 TURBO 4X4	2024	NaN	-1	154.0	4x4	mecanica
43347	MCO2335060240	Toyota Hilux 2024 2.8 Gr-s	https://carro.mercadolibre.com.co/MCO-2335060240-toyota-hilux-2024-28-gr-s-_JM	312000000	RAUTOSGROUP	bogota dc	blanco	no	toyota	4	2.8	diesel	200.0	hilux	2.8 Gr-S	2024	NaN	-1	201.0	4x4	automatica

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values